USE [D:\SOURCE\RAILWAYTRACKING2013\PERSONAL\ALBINA_BORISOVA\DIGDES.DSCHOOL.SUPS\DATABASE\SUPS.MDF]
GO
drop table [dbo].[Dislocation]
/****** Object:  Table [dbo].[Dislocation]    Script Date: 15.11.2013 12:19:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Dislocation](
	[CarNumber] [int] NULL,
	[Weight] [float] NULL,
	[ArrivalStation] [int] NULL, --FOREIGN KEY REFERENCES Station,
	[CargoCode] [nchar](5) NULL,
	[Cargo_FK] [int] Null,-- FOREIGN KEY REFERENCES Cargo,
	[ConsigneeCode] [nchar](4) NULL,
	[CarParkType] [nchar](2) NULL,
	[DispatchStation] [int] NULL,-- FOREIGN KEY REFERENCES Station,
	[OperationCode] [nchar](2) NULL,
	[OperationDateTime] [datetime] NULL,
	[OperationStation] [int] NULL,-- FOREIGN KEY REFERENCES Station,
	[RoadOfDelivery] int NULL,-- FOREIGN KEY REFERENCES Road,
	[RoadOfReception] int NULL,-- FOREIGN KEY REFERENCES Road,
	[TrainIndex] [nchar](13) NULL,
	[TrainNumber] [nchar](4) NULL,

	
	 )
	  ON [PRIMARY]



GO


